{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["目录","设置表","菜品信息表","毛利统计表","销售明细表","操作说明"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"目录","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"设置表","index":1,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["基础设置"]
["类别（可以修改，添加）"]
["主食"]
["小吃"]
["酒水\\饮料"]
["组合"]
["涮菜"]

{"sheet":"菜品信息表","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["菜品信息表"]
["序号","类别","名称","销售价","成本价","备注"]
[1,"主食","米饭",3,1.5]
[2,"主食","油条",3,2]
[3,"主食","肉蓉面",4,2]
[4,"主食","扯面",6,1.38]
[5]

{"sheet":"毛利统计表","index":3,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["销售毛利统计表"]
["序号","类别","名称","销售价","成本价","销售数量","销售金额","成本金额","毛利额","毛利率","备注"]
[1,"主食","米饭",{"$f":"IFERROR(VLOOKUP(C3,菜品信息表!C:F,2,0),\"\")","v":3},{"$f":"IFERROR(VLOOKUP(C3,菜品信息表!C:F,3,0),\"\")","v":1.5},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C3,销售明细表!E:E)","v":5},{"$f":"IFERROR(F3*D3,\"\")","v":15},{"$f":"IFERROR(F3*E3,\"\")","v":7.5},{"$f":"IFERROR(G3-H3,)","v":7.5},{"$f":"IFERROR(I3/G3,\"\")","v":0.5}]
[2,"主食","油条",{"$f":"IFERROR(VLOOKUP(C4,菜品信息表!C:F,2,0),\"\")","v":3},{"$f":"IFERROR(VLOOKUP(C4,菜品信息表!C:F,3,0),\"\")","v":2},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C4,销售明细表!E:E)","v":6},{"$f":"IFERROR(F4*D4,\"\")","v":18},{"$f":"IFERROR(F4*E4,\"\")","v":12},{"$f":"IFERROR(G4-H4,)","v":6},{"$f":"IFERROR(I4/G4,\"\")","v":0.333333333333333}]
[3,"主食","肉蓉面",{"$f":"IFERROR(VLOOKUP(C5,菜品信息表!C:F,2,0),\"\")","v":4},{"$f":"IFERROR(VLOOKUP(C5,菜品信息表!C:F,3,0),\"\")","v":2},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C5,销售明细表!E:E)","v":7},28,14,14,0.5]
[4,"主食","扯面",{"$f":"IFERROR(VLOOKUP(C6,菜品信息表!C:F,2,0),\"\")","v":6},{"$f":"IFERROR(VLOOKUP(C6,菜品信息表!C:F,3,0),\"\")","v":1.38},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C6,销售明细表!E:E)","v":8},48,11.04,36.96,0.77]
[5,"主食",null,{"$f":"IFERROR(VLOOKUP(C7,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C7,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C7,销售明细表!E:E)","v":0},"","",0,""]
[6,"主食",null,{"$f":"IFERROR(VLOOKUP(C8,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C8,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C8,销售明细表!E:E)","v":0},"","",0,""]
[7,"主食",null,{"$f":"IFERROR(VLOOKUP(C9,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C9,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C9,销售明细表!E:E)","v":0},"","",0,""]
[8,"主食",null,{"$f":"IFERROR(VLOOKUP(C10,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C10,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C10,销售明细表!E:E)","v":0},"","",0,""]
[9,"主食",null,{"$f":"IFERROR(VLOOKUP(C11,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C11,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C11,销售明细表!E:E)","v":0},"","",0,""]
[10,"主食",null,{"$f":"IFERROR(VLOOKUP(C12,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C12,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C12,销售明细表!E:E)","v":0},"","",0,""]
[11,"主食",null,{"$f":"IFERROR(VLOOKUP(C13,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C13,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C13,销售明细表!E:E)","v":0},"","",0,""]
[12,"主食",null,{"$f":"IFERROR(VLOOKUP(C14,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C14,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C14,销售明细表!E:E)","v":0},"","",0,""]
[13,"主食",null,{"$f":"IFERROR(VLOOKUP(C15,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C15,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C15,销售明细表!E:E)","v":0},"","",0,""]
[14,"主食",null,{"$f":"IFERROR(VLOOKUP(C16,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C16,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C16,销售明细表!E:E)","v":0},"","",0,""]
[15,"主食",null,{"$f":"IFERROR(VLOOKUP(C17,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C17,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C17,销售明细表!E:E)","v":0},"","",0,""]
["序号","类别","名称","销售价","成本价","销售数量","销售金额","成本金额","毛利额","毛利率","备注"]
[1,"小吃",null,{"$f":"IFERROR(VLOOKUP(C19,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C19,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C19,销售明细表!E:E)","v":0},{"$f":"IFERROR(F19*D19,\"\")","v":""},{"$f":"IFERROR(F19*E19,\"\")","v":""},{"$f":"IFERROR(G19-H19,)","v":0},{"$f":"IFERROR(I19/G19,\"\")","v":""}]
[2,"小吃",null,{"$f":"IFERROR(VLOOKUP(C20,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C20,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C20,销售明细表!E:E)","v":0},{"$f":"IFERROR(F20*D20,\"\")","v":""},{"$f":"IFERROR(F20*E20,\"\")","v":""},{"$f":"IFERROR(G20-H20,)","v":0},{"$f":"IFERROR(I20/G20,\"\")","v":""}]
[3,"小吃",null,{"$f":"IFERROR(VLOOKUP(C21,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C21,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C21,销售明细表!E:E)","v":0},"","",0,""]
[4,"小吃",null,{"$f":"IFERROR(VLOOKUP(C22,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C22,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C22,销售明细表!E:E)","v":0},"","",0,""]
[5,"小吃",null,{"$f":"IFERROR(VLOOKUP(C23,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C23,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C23,销售明细表!E:E)","v":0},"","",0,""]
[6,"小吃",null,{"$f":"IFERROR(VLOOKUP(C24,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C24,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C24,销售明细表!E:E)","v":0},"","",0,""]
[7,"小吃",null,{"$f":"IFERROR(VLOOKUP(C25,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C25,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C25,销售明细表!E:E)","v":0},"","",0,""]
[8,"小吃",null,{"$f":"IFERROR(VLOOKUP(C26,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C26,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C26,销售明细表!E:E)","v":0},"","",0,""]
[9,"小吃",null,{"$f":"IFERROR(VLOOKUP(C27,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C27,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C27,销售明细表!E:E)","v":0},"","",0,""]
[10,"小吃",null,{"$f":"IFERROR(VLOOKUP(C28,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C28,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C28,销售明细表!E:E)","v":0},"","",0,""]
[11,"小吃",null,{"$f":"IFERROR(VLOOKUP(C29,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C29,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C29,销售明细表!E:E)","v":0},"","",0,""]
[12,"小吃",null,{"$f":"IFERROR(VLOOKUP(C30,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C30,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C30,销售明细表!E:E)","v":0},"","",0,""]
[13,"小吃",null,{"$f":"IFERROR(VLOOKUP(C31,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C31,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C31,销售明细表!E:E)","v":0},"","",0,""]
[14,"小吃",null,{"$f":"IFERROR(VLOOKUP(C32,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C32,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C32,销售明细表!E:E)","v":0},"","",0,""]
[15,"小吃",null,{"$f":"IFERROR(VLOOKUP(C33,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C33,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C33,销售明细表!E:E)","v":0},"","",0,""]
["序号","类别","名称","销售价","成本价","销售数量","销售金额","成本金额","毛利额","毛利率","备注"]
[1,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C35,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C35,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C35,销售明细表!E:E)","v":0},{"$f":"IFERROR(F35*D35,\"\")","v":""},{"$f":"IFERROR(F35*E35,\"\")","v":""},{"$f":"IFERROR(G35-H35,)","v":0},{"$f":"IFERROR(I35/G35,\"\")","v":""}]
[2,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C36,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C36,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C36,销售明细表!E:E)","v":0},{"$f":"IFERROR(F36*D36,\"\")","v":""},{"$f":"IFERROR(F36*E36,\"\")","v":""},{"$f":"IFERROR(G36-H36,)","v":0},{"$f":"IFERROR(I36/G36,\"\")","v":""}]
[3,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C37,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C37,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C37,销售明细表!E:E)","v":0},"","",0,""]
[4,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C38,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C38,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C38,销售明细表!E:E)","v":0},"","",0,""]
[5,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C39,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C39,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C39,销售明细表!E:E)","v":0},"","",0,""]
[6,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C40,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C40,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C40,销售明细表!E:E)","v":0},"","",0,""]
[7,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C41,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C41,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C41,销售明细表!E:E)","v":0},"","",0,""]
[8,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C42,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C42,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C42,销售明细表!E:E)","v":0},"","",0,""]
[9,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C43,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C43,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C43,销售明细表!E:E)","v":0},"","",0,""]
[10,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C44,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C44,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C44,销售明细表!E:E)","v":0},"","",0,""]
[11,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C45,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C45,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C45,销售明细表!E:E)","v":0},"","",0,""]
[12,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C46,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C46,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C46,销售明细表!E:E)","v":0},"","",0,""]
[13,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C47,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C47,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C47,销售明细表!E:E)","v":0},"","",0,""]
[14,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C48,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C48,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C48,销售明细表!E:E)","v":0},"","",0,""]
[15,"酒水\\饮料",null,{"$f":"IFERROR(VLOOKUP(C49,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C49,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C49,销售明细表!E:E)","v":0},"","",0,""]
["序号","类别","名称","销售价","成本价","销售数量","销售金额","成本金额","毛利额","毛利率","备注"]
[1,"组合",null,{"$f":"IFERROR(VLOOKUP(C51,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C51,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C51,销售明细表!E:E)","v":0},{"$f":"IFERROR(F51*D51,\"\")","v":""},{"$f":"IFERROR(F51*E51,\"\")","v":""},{"$f":"IFERROR(G51-H51,)","v":0},{"$f":"IFERROR(I51/G51,\"\")","v":""}]
[2,"组合",null,{"$f":"IFERROR(VLOOKUP(C52,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C52,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C52,销售明细表!E:E)","v":0},{"$f":"IFERROR(F52*D52,\"\")","v":""},{"$f":"IFERROR(F52*E52,\"\")","v":""},{"$f":"IFERROR(G52-H52,)","v":0},{"$f":"IFERROR(I52/G52,\"\")","v":""}]
[3,"组合",null,{"$f":"IFERROR(VLOOKUP(C53,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C53,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C53,销售明细表!E:E)","v":0},"","",0,""]
[4,"组合",null,{"$f":"IFERROR(VLOOKUP(C54,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C54,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C54,销售明细表!E:E)","v":0},"","",0,""]
[5,"组合",null,{"$f":"IFERROR(VLOOKUP(C55,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C55,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C55,销售明细表!E:E)","v":0},"","",0,""]
[6,"组合",null,{"$f":"IFERROR(VLOOKUP(C56,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C56,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C56,销售明细表!E:E)","v":0},"","",0,""]
[7,"组合",null,{"$f":"IFERROR(VLOOKUP(C57,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C57,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C57,销售明细表!E:E)","v":0},"","",0,""]
[8,"组合",null,{"$f":"IFERROR(VLOOKUP(C58,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C58,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C58,销售明细表!E:E)","v":0},"","",0,""]
[9,"组合",null,{"$f":"IFERROR(VLOOKUP(C59,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C59,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C59,销售明细表!E:E)","v":0},"","",0,""]
[10,"组合",null,{"$f":"IFERROR(VLOOKUP(C60,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C60,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C60,销售明细表!E:E)","v":0},"","",0,""]
[11,"组合",null,{"$f":"IFERROR(VLOOKUP(C61,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C61,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C61,销售明细表!E:E)","v":0},"","",0,""]
[12,"组合",null,{"$f":"IFERROR(VLOOKUP(C62,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C62,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C62,销售明细表!E:E)","v":0},"","",0,""]
[13,"组合",null,{"$f":"IFERROR(VLOOKUP(C63,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C63,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C63,销售明细表!E:E)","v":0},"","",0,""]
[14,"组合",null,{"$f":"IFERROR(VLOOKUP(C64,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C64,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C64,销售明细表!E:E)","v":0},"","",0,""]
[15,"组合",null,{"$f":"IFERROR(VLOOKUP(C65,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C65,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C65,销售明细表!E:E)","v":0},"","",0,""]
["序号","类别","名称","销售价","成本价","销售数量","销售金额","成本金额","毛利额","毛利率","备注"]
[1,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C67,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C67,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C67,销售明细表!E:E)","v":0},{"$f":"IFERROR(F67*D67,\"\")","v":""},{"$f":"IFERROR(F67*E67,\"\")","v":""},{"$f":"IFERROR(G67-H67,)","v":0},{"$f":"IFERROR(I67/G67,\"\")","v":""}]
[2,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C68,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C68,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C68,销售明细表!E:E)","v":0},{"$f":"IFERROR(F68*D68,\"\")","v":""},{"$f":"IFERROR(F68*E68,\"\")","v":""},{"$f":"IFERROR(G68-H68,)","v":0},{"$f":"IFERROR(I68/G68,\"\")","v":""}]
[3,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C69,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C69,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C69,销售明细表!E:E)","v":0},"","",0,""]
[4,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C70,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C70,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C70,销售明细表!E:E)","v":0},"","",0,""]
[5,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C71,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C71,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C71,销售明细表!E:E)","v":0},"","",0,""]
[6,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C72,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C72,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C72,销售明细表!E:E)","v":0},"","",0,""]
[7,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C73,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C73,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C73,销售明细表!E:E)","v":0},"","",0,""]
[8,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C74,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C74,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C74,销售明细表!E:E)","v":0},"","",0,""]
[9,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C75,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C75,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C75,销售明细表!E:E)","v":0},"","",0,""]
[10,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C76,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C76,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C76,销售明细表!E:E)","v":0},"","",0,""]
[11,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C77,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C77,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C77,销售明细表!E:E)","v":0},"","",0,""]
[12,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C78,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C78,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C78,销售明细表!E:E)","v":0},"","",0,""]
[13,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C79,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C79,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C79,销售明细表!E:E)","v":0},"","",0,""]
[14,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C80,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C80,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C80,销售明细表!E:E)","v":0},"","",0,""]
[15,"涮菜",null,{"$f":"IFERROR(VLOOKUP(C81,菜品信息表!C:F,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C81,菜品信息表!C:F,3,0),\"\")","v":""},{"$f":"SUMIF(销售明细表!D:F,毛利统计表!C81,销售明细表!E:E)","v":0},"","",0,""]

{"sheet":"销售明细表","index":4,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["销售明细表"]
["序号","时间","类别","名称","数量","备注"]
[1,"2021-03-01","主食","米饭",5]
[2,"2021-03-02","主食","油条",6]
[3,"2021-03-05","主食","肉蓉面",7]
[4,"2021-03-06","主食","扯面",8]

{"sheet":"操作说明","index":5,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["使用说明"]
["1、“设置表”里面设置菜品类别。"]
["2、“菜品信息表”填写菜品详细信息、成本价、售价。"]
["3、在“销售明细表”里面填写销售详细信息。"]
["4、“毛利统计表”会自动统计相关产品毛利信息。"]